Best Tools for JAVA/Best Tools for JAVA.iso/JAVA_ALL/JDBC/JDBC_TES/JDBC-TES.ZIP/jdbc-tests/sqlserver-resources/jdbcTest.data.CreateProcedures.ini

INI File | 1996-10-18 | 3.9 KB | 74 lines

;The names of the procedures indicate the CallableStatement tests
;they are used in. The meta data for the JDBC_SET_STRING procedure
;is referenced in the dbmetadata.GetProcedures test.


[Setup]
@@CREATE PROCEDURE JDBC_GET_BOOLEAN @FTMP BIT OUTPUT AS SELECT @FTMP=BITCOL  FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_BYTE @ICOL TINYINT OUTPUT AS SELECT @ICOL=TINYINTCOL  FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_BYTES @BTMP BINARY(10) OUTPUT AS SELECT @BTMP=BINCOL  FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_VBYTES @BTMP VARBINARY(10) OUTPUT AS SELECT @BTMP=VARBINCOL FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_DATE @ITMP DATETIME OUTPUT AS SELECT @ITMP=DATECOL FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_DOUBLE @FTMP FLOAT OUTPUT AS SELECT @FTMP=DOUBLECOL FROM JDBCTEST WHERE INTEGERCOL = 2

@@CREATE PROCEDURE JDBC_GET_FLOAT @FTMP REAL OUTPUT AS SELECT @FTMP=REALCOL FROM JDBCTEST WHERE INTEGERCOL = 2

@@CREATE PROCEDURE JDBC_GET_INT @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE SMALLCOL = 4

@@CREATE PROCEDURE JDBC_GET_LONG @ICOL INT OUTPUT AS SELECT @ICOL=BIGINTCOL FROM JDBCTEST WHERE INTEGERCOL = 2

@@CREATE PROCEDURE JDBC_GET_BIGNUM @ICOL NUMERIC OUTPUT AS SELECT @ICOL=NUMERICCOL FROM JDBCTEST WHERE INTEGERCOL = 2

@@CREATE PROCEDURE JDBC_GET_SHORT @ICOL SMALLINT OUTPUT AS SELECT @ICOL=SMALLCOL FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_STRING @CCOL CHAR(10) OUTPUT AS SELECT @CCOL=CHARCOL FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_VSTRING @CCOL VARCHAR(10) OUTPUT AS SELECT @CCOL=VCHARCOL FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_TIME @ITMP DATETIME OUTPUT AS SELECT @ITMP=TIMECOL FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_TIMESTAMP @ITMP DATETIME OUTPUT AS SELECT @ITMP=TSCOL FROM JDBCTEST WHERE INTEGERCOL = 1

@@CREATE PROCEDURE JDBC_GET_NULL @CCOL CHAR(10) OUTPUT AS SELECT @CCOL=CHARCOL FROM JDBCTEST WHERE INTEGERCOL = 5



@@CREATE PROCEDURE JDBC_SET_BOOLEAN @FTMP  BIT, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE BITCOL = @FTMP

@@CREATE PROCEDURE JDBC_SET_BYTE @NCOL TINYINT, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE TINYINTCOL = @NCOL

@@CREATE PROCEDURE JDBC_SET_BYTES @BTMP  VARBINARY(10), @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE VARBINCOL = @BTMP

@@CREATE PROCEDURE JDBC_SET_DATE @ITMP  DATETIME, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE DATECOL = @ITMP

@@CREATE PROCEDURE JDBC_SET_DOUBLE @FTMP  FLOAT, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE DOUBLECOL > @FTMP AND DOUBLECOL < 10.0

@@CREATE PROCEDURE JDBC_SET_FLOAT @FTMP  REAL, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE REALCOL > @FTMP AND REALCOL < 1.5

@@CREATE PROCEDURE JDBC_SET_INT @NCOL  INT, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE INTEGERCOL = @NCOL

@@CREATE PROCEDURE JDBC_SET_LONG @NCOL  INT, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE BIGINTCOL = @NCOL

@@CREATE PROCEDURE JDBC_SET_BIGNUM @NCOL NUMERIC, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE NUMERICCOL = @NCOL

@@CREATE PROCEDURE JDBC_SET_SHORT @NCOL  SMALLINT, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE SMALLCOL = @NCOL

@@CREATE PROCEDURE JDBC_SET_STRING @CCOL  CHAR(10), @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE CHARCOL = @CCOL

@@CREATE PROCEDURE JDBC_SET_TIME @ITMP  DATETIME, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE TIMECOL = @ITMP

@@CREATE PROCEDURE JDBC_SET_TIMESTAMP @ITMP  DATETIME, @ICOL INT OUTPUT AS SELECT @ICOL=INTEGERCOL FROM JDBCTEST WHERE TSCOL = @ITMP

@@CREATE PROCEDURE JDBC_SET_NULL @NCOL CHAR(10) AS INSERT INTO JDBC_NULL_TEST (NAME,VALUE) VALUES('CallableStatement', @NCOL)